package cn.lanqiao.bigDate.mapper.data;

import cn.lanqiao.bigDate.entity.data.DataBookLabelHeading;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

@Mapper
public interface DataBookLabelHeadingMapper extends BaseMapper<DataBookLabelHeading> {
    @Select("select dl.label_name,COUNT(1) as count from data_book db,data_book_label_heading dbl,data_label dl where db.isbn=dbl.isbn and dbl.label_id=dl.id GROUP BY dl.id")
    List<Map<String,Integer>> findClassify();
}
